Skip to main content

EXECUTING READ_WRITE_DML

Short Description

The activity is executing work of type WRITE_DML

Detailed Description​

The activity state is EXECUTING and work type is READ_WRITE_DML

How to reduce this wait​

If there is significant time spent in this state, then you might need to optimise write activity by query tuning, indexing or using faster storage.

Db2 docs - Classes States Connections Activities in Service Class

Db2 docs - Work Identification by Type Cost Data Accessed Work Classes

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.